package com.gilstar.common;

public class Constant 
{
	
	public static final String UPLOAD_PATH = "/var/www/main/upload";
	
	/*********************************************************************************************
	 * json object keys
	 ********************************************************************************************/
	
	public static final String REQ = "req";
	
	public static final String TITLE = "title";
	
	public static final String ARTIST = "artist";
	
	public static final String CATEGORY = "category";
	
	public static final String LATITUDE = "latitude";
	
	public static final String LONGITUDE = "longitude";
	
	public static final String TIME = "time";
	
	public static final String DATE = "date";
	
	public static final String DAY_ADD = "day_add";
	
	public static final String CONTENT = "content";
	
	public static final String EMAIL = "email";
	
	public static final String SNS_URL = "sns_url";
	
	public static final String LIKE_IT_COUNT = "like_it_count";
	
	public static final String PERFORMANCE_SEQ = "performance_seq";
	
	public static final String FILE_TYPE = "file_type";
	
	public static final String FILE_NAME = "file_name";
	
	public static final String FILE_PATH = "file_path";
	
	public static final String FILE_SIZE = "file_size";
	
	public static final String USER_SEQ = "user_seq";
	
	public static final String PASSWORD = "password";
	
	public static final String NAME = "name";
	
	public static final String COMMENT_CONTENT = "commmet_content";
	
	public static final String NORTH_EAST = "north_east";
	
	public static final String SOUTH_WEST = "south_west";
	
	public static final String YOUTUBE_LINK = "youtube_link";
	
	public static final String MAX_LATITUDE = "maxLatitude";
	
	public static final String MAX_LONGITUDE = "maxLongitude";
	
	public static final String MIN_LATITUDE = "minLatitude";
	
	public static final String MIN_LONGITUDE = "minLongitude";
	
	public static final String MAX_TIME = "maxTime";
	
	public static final String MIN_TIME = "minTime";
	
	public static final String PERFORMANCE_FILE = "performance_file";
	
	public static final String KEYWORD = "keyword";
	
	public static final String CONDITION = "condition";
	
	public static final String PAGE_NO = "page_no";
	
	public static final String PAGE_ROW_COUNT = "page_count";
	
	public static final int PAGE_ROW_COUNT_VALUE = 5;
	
	public static final String HOT_SPOT_SEQ = "hot_spot_seq";
	
	public static final String ADDRESS = "address";
	
	
	/*********************************************************************************************
	 * request names
	 ********************************************************************************************/
	public static final String METHOD_NAME_REGISTER_PERFORMANCE = "REGISTER_PERFORMANCE";
	
	public static final String METHOD_NAME_GET_PERFORMANCE_FROM_MAP = "GET_PERFORMANCE_FROM_MAP";

	public static final String METHOD_NAME_GET_PERFORMANCE_FROM_LIST = "GET_PERFORMANCE_FROM_LIST";
	
	public static final String METHOD_NAME_GET_PERFORMANCE_DETAIL = "GET_PERFORMANCE_DETAIL";
	
	public static final String METHOD_NAME_GET_PERFORMANCE_LIST = "GET_PERFORMANCE_LIST";
	
	public static final String METHOD_NAME_ADD_COMMENT = "ADD_COMMENT";
	
	public static final String METHOD_NAME_GET_COMMENT_LIST = "GET_COMMENT_LIST";
	
	public static final String METHOD_NAME_GET_NEAREST_HOTSPOT = "GET_NEAREST_HOTSPOT";
	
	public static final String METHOD_NAME_GET_HOTSPOT_LIST = "GET_HOTSPOT_LIST";
	
	public static final String METHOD_NAME_GET_RANDOM_PERFORMANCE = "GET_RANDOM_PERFORMANCE";
	
	public static final String METHOD_NAME_GET_ADDRESS = "GET_ADDRESS";
	
	public static final String METHOD_NAME_DELETE_PERFORMANCE = "DELETE_PERFORMANCE";
	
	/*********************************************************************************************
	 * util constants
	 ********************************************************************************************/
	
	public static final String EMPTY = "";
	
	public static final String CV_UTF8 = "utf-8";
	
	public static final String DOT = ".";
	
	/*********************************************************************************************
	 * response messages
	 ********************************************************************************************/
	
	public static final String INSERT_OK = "insert_ok";
	
	public static final String ERROR_MESSAGE = "서버에 오류가 발생하였습니다.\n관리자에게 문의하시길 바랍니다.";
	
	public static final String NO_USER_EXIST = "사용자가 존재하지 않습니다.";
	
	public static final String LOGIN_REQUIRED_SERVICE = "로그인이 필요한 서비스입니다.";
	
	public static final String TITLE_INVAILIDE_MESSAGE = "제목이 잘못 입력되었습니다.";
	
	public static final String LATITUDE_INVALIDE_MESSAGE = "위도가 잘못되었습니다.";
	
	public static final String LONGITUDE_INVALIDE_MESSAGE = "경도가 잘못되었습니다.";
	
	public static final String LOCATION_INVALID_MESSAGE = "현재위치가 잘못되었습니다.";
	
	public static final String FILE_INSERT_INVALID_MESSAGE = "파일등록 중 오류가 발생하였습니다.";
	
	public static final String PERFORMANCE_SEQ_INVALID_MESSAGE = "공연 등록 정보가 잘못되었습니다.";
	
	public static final String INVALID_PAGE_NUMBER_MESSAGE = "페이지 번호가 잘못되었습니다.";
	
	public static final String ANY_HOT_SPOT_REGISTERED = "등록된 핫스팟이 없습니다.";
	
	
	/*********************************************************************************************
	 * sql mapping names 
	 ********************************************************************************************/
	public static final String SQLMAP_SEARCH_EMAIL = "Performance.searchEmail";
	
	public static final String SQLMAP_INSERT_PERFORMANCE = "Performance.insertPerformance";
	
	public static final String SQLMAP_INSERT_PERFORMNACE_FILE = "Performance.insertPerformanceFile";
	
	public static final String SQLMAP_INSERT_COMMENT = "Performance.insertComment";
	
	public static final String SQLMAP_SELECT_PERFORMANCE_FROM_MAP = "Performance.selectPerformanceFromMap";
	
	public static final String SQLMAP_SELECT_PERFORMANCE_FROM_LIST = "Performance.selectPerformanceFromList";
	
	public static final String SQLMAP_SELECT_PERFORMANCE_DETAIL = "Performance.selectPerformanceDetail";
	
	public static final String SQLMAP_SELECT_PERFORMANCE_FILE = "Performance.selectPerformanceFile";
	
	public static final String SQLMAP_SELECT_PERFORMANCE_LIST = "Performance.selectPerformanceList";
	
	public static final String SQLMAP_SELECT_COMMENT = "Performance.selectComment";
	
	public static final String SQLMAP_SELECT_ALL_HOTSPOT = "Performance.selectAllHotSpot";
	
	public static final String SQLMAP_SELECT_HOT_SPOT = "Performance.selectHotSpot";
	
	public static final String SQLMAP_SELECT_RANDOM_PERFORMANCE = "Performance.selectRandomPerformance";
	
	public static final String SQLMAP_DELETE_PERFORMANCE = "Performance.deletePerformance";
	
}
